SharkD wrote:
> It's also the choice of words that are used for some of the commands 
> that irks me. Instead of SELECT I would have used GET. Instead of 
> TRIGGER I would have used EVENT.

That's because you're thinking procedurally instead of declaritively.

You're thinking "The server gets a bunch of rows", instead of "the result is 
the selection of the rows that meet this criteria." You're thinking "The 
server runs this code when it gets an insertion event", rather than "this is 
the code that's triggered by an insertion."

> Instead of JOIN I would have used INTERSECT. 

Join is closer to a union than an intersection. It's actually a cartesian 
product. If you join a 3-row table to a 5-row table, you get a 15-row table.

That said, SQL is indeed one of those languages for which I regularly have 
to look up the syntax even for simple stuff. :-)

-- 
   Darren New, San Diego CA, USA (PST)
   I ordered stamps from Zazzle that read "Place Stamp Here".

Post a reply to this message